When we need to replace blank values with 0, use below DAX formula for Measure.
Audit Count = IF (
CALCULATE ( COUNT ( 'Audit Master Data'[Ref.] )) = BLANK (),
0,
CALCULATE ( COUNT ( 'Audit Master Data'[Ref.] ) )
)
Happy Learning !! :)
Subscribe to:
Post Comments (Atom)
-
OBIEE 12C or OAS has removed the option to upload RPD through EM page. We will have to upload or download RPD through command prompt only....
-
Sometime we have requirement to put any kind of Custom Link along with the OAS Global Header. In order to do we will have to do two things....
-
Below is the syntax to run catalog manager report through command line. ./runcat.sh -cmd report -offline CATALOG_PATH -outputFile EXPORT_R...
No comments:
Post a Comment