Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power BI Calculate

Hi,

 

I have a bar char in my dashboard which show a measures for %Clicked by officer name.I want that by default it should the %Clicked for the Current month but if user select a filter for Last month then it should show for that month.

 

I have a Datedimension table which determine if this is a "Current Month" or else it show 2020-06 etc.

 

Report Month = IF(MONTH(now()) = Month(DateDim[Date]) && YEAR(now()) = YEAR(DateDim[Date]), "Current Month", DateDim[Year-Month])
 
My
Percentage Clicked current month = CALCULATE([Clicked #]/ [Total Users],FILTER(DateDim,DateDim[Report Month] = "Current Month")))
 
 
This works for Current Month but if I select a filter for June or Jan it does not calculate anything.
Thanks
POWER BI Dax rules
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Anonymous  - Perhaps try this:

     

    Percentage Clicked current month =

    IF(HASONEVALUE(DateDim[Report Month), [Clicked #] / [Total Users], CALCULATE([Clicked #]/ [Total Users],FILTER(DateDim,DateDim[Report Month] = "Current Month")))

     

    Woudl be easier with sample data, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

    The most important parts are:
    1. Sample data as text, use the table tool in the editing bar
    2. Expected output from sample data
    3. Explanation in words of how to get from 1. to 2.

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous  - Perhaps try this:

     

    Percentage Clicked current month =

    IF(HASONEVALUE(DateDim[Report Month), [Clicked #] / [Total Users], CALCULATE([Clicked #]/ [Total Users],FILTER(DateDim,DateDim[Report Month] = "Current Month")))

     

    Woudl be easier with sample data, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

    The most important parts are:
    1. Sample data as text, use the table tool in the editing bar
    2. Expected output from sample data
    3. Explanation in words of how to get from 1. to 2.